<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Return_model extends CI_Model {

    function __construct()
    {
        parent::__construct();
    }
	
	function get_url($orderid){
	
		$sql = "SELECT siteid FROM sdk_order WHERE orderid = '" . $orderid . "' ";
		$q = $this->db->query($sql);
		$rs = $q->first_row(); 
		
		$sql = "SELECT sitename FROM sdk_site WHERE siteid = '" . $rs->siteid . "' ";
		$q = $this->db->query($sql);
		$rs = $q->first_row();
		
		return $rs->sitename;
	}
	
	
}